package com.ship.dispatch.mapper.fob;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ship.dispatch.bean.fob.SpFobJsfhccbItems;
import com.ship.dispatch.bean.fob.SpfobUpjsfhccb;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author yl
 * @title SpfobUpjsfhccbMapper
 * @description
 * @create 2024/1/1 0001
 */
public interface SpfobUpjsfhccbMapper extends BaseMapper<SpfobUpjsfhccb> {
    @Select("select * from sp_fob_jsfhccb_items where jsfhccb_id=#{jsfhccbId} and \n" +
            "table_id in ('CharterCost','ShippingAgencyCost','Insurance','LSMGO','VLSFO','PositioningFee','BallastBonus','BOG')\n" +
            "and (a1='Total' or a1='Total price' or a1='Estimated discharge quantity' or a1='Shipping cost')")
    List<SpFobJsfhccbItems> findListByServiceId(@Param("jsfhccbId") Long jsfhccbId);
}
